CREATE TABLE [dbo].[Name_Staff]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Staff_ID] DEFAULT (''),
[IS_VOLUNTEER] [bit] NOT NULL CONSTRAINT [DF_Name_Staff_IS_VOLUNTEER] DEFAULT ((0)),
[IS_SALESMAN] [bit] NOT NULL CONSTRAINT [DF_Name_Staff_IS_SALESMAN] DEFAULT ((0)),
[HOURS_PER_WEEK] [numeric] (15, 1) NOT NULL CONSTRAINT [DF_Name_Staff_HOURS_PER_WEEK] DEFAULT ((0)),
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Staff_DESCRIPTION] DEFAULT (''),
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
GRANT REFERENCES ON  [dbo].[Name_Staff] TO [IMIS]
GRANT SELECT ON  [dbo].[Name_Staff] TO [IMIS]
GRANT INSERT ON  [dbo].[Name_Staff] TO [IMIS]
GRANT DELETE ON  [dbo].[Name_Staff] TO [IMIS]
GRANT UPDATE ON  [dbo].[Name_Staff] TO [IMIS]
GO